/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 713

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 52 45 53 |CHILD DE|LETE RES|
|00000010| 54 52 49 43 54 00 21 20 | 20 20 45 52 77 69 6e 20 |TRICT.! |  ERwin |
|00000020| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00000030| 65 0d 0a 21 20 20 20 25 | 50 61 72 65 6e 74 20 25 |e..!   %|Parent %|
|00000040| 56 65 72 62 50 68 72 61 | 73 65 20 25 43 68 69 6c |VerbPhra|se %Chil|
|00000050| 64 20 4f 4e 20 43 48 49 | 4c 44 20 44 45 4c 45 54 |d ON CHI|LD DELET|
|00000060| 45 20 52 45 53 54 52 49 | 43 54 0d 0a 20 20 20 20 |E RESTRI|CT..    |
|00000070| 63 61 6c 6c 20 53 71 6c | 49 6d 6d 65 64 69 61 74 |call Sql|Immediat|
|00000080| 65 28 27 73 65 6c 65 63 | 74 20 63 6f 75 6e 74 28 |e('selec|t count(|
|00000090| 2a 29 20 69 6e 74 6f 20 | 3a 6e 75 6d 72 6f 77 73 |*) into |:numrows|
|000000a0| 20 66 72 6f 6d 20 25 50 | 61 72 65 6e 74 20 77 68 | from %P|arent wh|
|000000b0| 65 72 65 20 25 46 6f 72 | 45 61 63 68 46 4b 41 74 |ere %For|EachFKAt|
|000000c0| 74 28 22 61 6e 64 20 22 | 29 7b 20 25 50 61 72 65 |t("and "|){ %Pare|
|000000d0| 6e 74 2e 25 50 61 72 65 | 6e 74 41 74 74 28 25 41 |nt.%Pare|ntAtt(%A|
|000000e0| 74 74 46 69 65 6c 64 4e | 61 6d 65 29 20 3d 20 3a |ttFieldN|ame) = :|
|000000f0| 25 41 74 74 46 69 65 6c | 64 4e 61 6d 65 20 7d 27 |%AttFiel|dName }'|
|00000100| 29 0d 0a 20 20 20 20 69 | 66 20 6e 75 6d 72 6f 77 |)..    i|f numrow|
|00000110| 73 20 3e 20 30 0d 0a 20 | 20 20 20 20 20 72 65 74 |s > 0.. |     ret|
|00000120| 75 72 6e 20 32 30 30 30 | 0d 0a 00 20 27          |urn 2000|... '   |
+--------+-------------------------+-------------------------+--------+--------+